UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0x9hHN1Duhi8+y3GcfNedn5YkJOzadWm9MK2TKSu2/c='
WHERE
key_id = '246b38f26464012e4b15e0d37d6b368f792b1ccb72f033f10e00ae8b2990cc1c'
AND (
token = '0x9hHN1Duhi8+y3GcfNedn5YkJOzadWm9MK2TKSu2/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)