UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8o2aTm/lKhRAY6l8fBFzA9g9XECMRgAaGF72ZvXp8Ac='
WHERE
key_id = '7ceeaf6df30a0aab1bf72a5f4c4786a14424b45ada71e2916ea6641580fb330d'
AND (
token = '8o2aTm/lKhRAY6l8fBFzA9g9XECMRgAaGF72ZvXp8Ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)