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