UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yENov5WKiY9LVX4go8W0Z35np37It9XmVhwDwUASdc='
WHERE
key_id = '0b0a3e7c886acef532c63e3f5df8a9b12b1bf9b61dbf8cabb1fa37d939b69ece'
AND (
token = '8yENov5WKiY9LVX4go8W0Z35np37It9XmVhwDwUASdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)