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