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