UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6lQuphTt2UGzNcur8xIsJi/HY9aigTy/AKpp3Ye5Als='
WHERE
key_id = 'bcd4d6b80ed60689b3f99931b7a5186533ffbd9c55ac08283e14f4ac5c9dbda2'
AND (
token = '6lQuphTt2UGzNcur8xIsJi/HY9aigTy/AKpp3Ye5Als='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)