UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYmyneIu+FztKJOD6Jfdf4pZWauJth0+Ycs/bxQz6aE='
WHERE
key_id = 'ead397a5e106bf904bfc141742fe9df6355836915023c020bd322c724aa2673a'
AND (
token = 'XYmyneIu+FztKJOD6Jfdf4pZWauJth0+Ycs/bxQz6aE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)