UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v23dJDV+GTJPWX8IMMmpBmLwdikLP47jy4RXYiYtglg='
WHERE
key_id = '406828f490b881f8df5e5e87789e0eab51b55874726c1565a2c6e81d779887ae'
AND (
token = 'v23dJDV+GTJPWX8IMMmpBmLwdikLP47jy4RXYiYtglg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)