UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'McnPhLnk8eMxSZmn8isGDJnHXFcVsrwtBJMh2hBk6Mg='
WHERE
key_id = '0c1a4bf16e15b3a3fdf4561f47be830a3783c00f2a94999134214d30c4f62bbe'
AND (
token = 'McnPhLnk8eMxSZmn8isGDJnHXFcVsrwtBJMh2hBk6Mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)