UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '05y9ZEgCSpqSI8HzPEIq+2yFUdR+jyQ70o+yTCabRjc='
WHERE
key_id = '4ec6e56b70f5e2351199ab85828535239b47f622934f801e2ca44ca608125647'
AND (
token = '05y9ZEgCSpqSI8HzPEIq+2yFUdR+jyQ70o+yTCabRjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)