UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qL5AlbrnUXQL3xsiYP9RiOLNcht20iKQ0+KhdjgccoI='
WHERE
key_id = 'aa47af4a7bea8e61505fc2b5c133af6c227474a315ea8101b4cdda3a15c48be8'
AND (
token = 'qL5AlbrnUXQL3xsiYP9RiOLNcht20iKQ0+KhdjgccoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)