UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tcBih2oHuswBEKVCBIK7INcSJ8M/z+CrQHO42d9Icc='
WHERE
key_id = 'c3fd60c37a5b7fe27407a0f12389f9b93fedfec046f587f42a3e986b94f580f4'
AND (
token = '7tcBih2oHuswBEKVCBIK7INcSJ8M/z+CrQHO42d9Icc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)