UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pi9/0OZW29WUnr8V1QL0+sFDlEe581Xyf0/aeXIoKrs='
WHERE
key_id = '9a91c0bf36d60d6a24fe0964e0b39189ec5e814f3c76ca84ba3ceb688217ba3e'
AND (
token = 'Pi9/0OZW29WUnr8V1QL0+sFDlEe581Xyf0/aeXIoKrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)