UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmONBRGvKaAab3ZSIQ8pvuRZ4Lc/2kTDod8EBFrOCF0='
WHERE
key_id = 'e3e86c8bd07169c5961f6c3c919dfebe598571009a4ac3a2f9d12badb4ba2028'
AND (
token = 'CmONBRGvKaAab3ZSIQ8pvuRZ4Lc/2kTDod8EBFrOCF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)