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