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