UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7c1qMb+zE49RESgSmH/vocb393c5IMVyuUyq/CtgdZk='
WHERE
key_id = 'e3b46d0ce762116a234455303da86f960cd4a893b172b390b6c64a2ad7c7abcd'
AND (
token = '7c1qMb+zE49RESgSmH/vocb393c5IMVyuUyq/CtgdZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)