UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3bNMNDJl8m66cR9/YV+CUjd+mRxLjTkpXk3jcug3LpY='
WHERE
key_id = '8a340cacc3fc30b3636cbe4f248a1446ead8de7c9b1ecb12ec2faaec64ab9d61'
AND (
token = '3bNMNDJl8m66cR9/YV+CUjd+mRxLjTkpXk3jcug3LpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)