UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bwc1alxyeouq8dnITIKXqTN84tZr8A8Zt8aESuWF560='
WHERE
key_id = '20191c846467aff69cc8a20cdc87beb67b53ffd4d1703655681162a73e80f22f'
AND (
token = 'Bwc1alxyeouq8dnITIKXqTN84tZr8A8Zt8aESuWF560='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)