UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/gdiLbr8TEBOZI/IxAG2VHl/+oKw4Gp4PYhcZ3/FRkE='
WHERE
key_id = 'c1b67fed2a402438d1cd7cc69ee44dd143b792d8019409c05008f1e732241cc0'
AND (
token = '/gdiLbr8TEBOZI/IxAG2VHl/+oKw4Gp4PYhcZ3/FRkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)