UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//ANQnsTkW6KNPmSDJibM6RZHxsImxsf2EcndyrL8nU='
WHERE
key_id = '587e13fd80a9fcd0b9b7212bd67a6f8712670a9354e62ccc5fc255febe092c21'
AND (
token = '//ANQnsTkW6KNPmSDJibM6RZHxsImxsf2EcndyrL8nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)