UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JNefa5f6XvnAsIKxvwaLO2eFmQFTbUK11162zZ4sx0Q='
WHERE
key_id = 'ec6adc032fdb4ca228af69f6359368be01f352db8d5c741f2213c644cc58c57a'
AND (
token = 'JNefa5f6XvnAsIKxvwaLO2eFmQFTbUK11162zZ4sx0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)