UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgN8OW8IiiAIYhYT5W87esXeHjTvLeIjwUVTTp0+mCo='
WHERE
key_id = '475d7f2a10a0e67e1871482d26bc871f659fe8dd93bd4fa1fed3ae5ddafa063d'
AND (
token = 'YgN8OW8IiiAIYhYT5W87esXeHjTvLeIjwUVTTp0+mCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)