UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BV7CDpdkJi1nsiHVv0QehGUlwxaLBIjKjzvo4ykJrpo='
WHERE
key_id = '8a3d43cbe567e915a9c8ed316285580d21a52fa9c239341d6beeb69cd60a9bdb'
AND (
token = 'BV7CDpdkJi1nsiHVv0QehGUlwxaLBIjKjzvo4ykJrpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)