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