UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcnuibaC0+YgD3vj/RcX9sRdidSe53UNHJ6Cutnvpy0='
WHERE
key_id = '6c3e0159ae0015253be3948927e644440e78ecfed6a9377ff7039e22804eef3c'
AND (
token = 'zcnuibaC0+YgD3vj/RcX9sRdidSe53UNHJ6Cutnvpy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)