UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnaYg9XmGhKUvWY8/LZCORu1pK3JLr2vVbCdhK0Sy9o='
WHERE
key_id = 'afd3a092299f1e075169f63f9a1cb75e6d9d13db43d11a462bd9490a379a3bca'
AND (
token = 'KnaYg9XmGhKUvWY8/LZCORu1pK3JLr2vVbCdhK0Sy9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)