UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jtAqRTIOvwG39jcZW59i2ozYjazCT6OnG+LS69NXRsw='
WHERE
key_id = 'e974998892b774a5c9711b41c5f8e5a5f96aca85a1e1a5897127de7f74a3d789'
AND (
token = 'jtAqRTIOvwG39jcZW59i2ozYjazCT6OnG+LS69NXRsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)