UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KP0Tz4zr9IAegaSP1oLl8VZGj9BGcTeBucEQeqNt2d0='
WHERE
key_id = '1a00f9caf1a4e49090ce9214e393e63eaf424980342e21dd8edc21a92776a58c'
AND (
token = 'KP0Tz4zr9IAegaSP1oLl8VZGj9BGcTeBucEQeqNt2d0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)