UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xz5NT6lZ5iGiELgHVIIezdf6AvaxZj2R082FKD2I6O0='
WHERE
key_id = '6f68e50e12d1e666b14801b1cbf2a13a40292e4874c0e49826c45fced03e7c14'
AND (
token = 'Xz5NT6lZ5iGiELgHVIIezdf6AvaxZj2R082FKD2I6O0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)