UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yqJHi1L+il1tEHXAkv78P4gHCdUmPh1FCweXCHB5U8g='
WHERE
key_id = '93c79143afd7382c388117b7d650f35b5a157cea41fb6d7c3908ff81ac38e6b9'
AND (
token = 'yqJHi1L+il1tEHXAkv78P4gHCdUmPh1FCweXCHB5U8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)