UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hu1JuhNSYddAPn6zRLi3tvxiJeX9CEOsG8gSP3FYHkw='
WHERE
key_id = 'e7c91b7b7d1e84f2dbeabd8dd0b2fefb9481bc2e627d74988a0609aceee999cf'
AND (
token = 'Hu1JuhNSYddAPn6zRLi3tvxiJeX9CEOsG8gSP3FYHkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)