UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnkXcSoHlEv7VYqMEtQ8aKFJQKJAQZPIHmxWv6E4Y6Y='
WHERE
key_id = '58f1d830de5d70d71ea13af29854cf432e9ebe689c5ae7cc4f1f16cb725b939a'
AND (
token = 'HnkXcSoHlEv7VYqMEtQ8aKFJQKJAQZPIHmxWv6E4Y6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)