UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SNMdWPXnlH5ulnSKvPTTPJp2OwJSIHMTiBqOeG276ck='
WHERE
key_id = '577d5f746e515eb23914e061b158af28080959aedb0f000c4a7c5bcb75fc0a1e'
AND (
token = 'SNMdWPXnlH5ulnSKvPTTPJp2OwJSIHMTiBqOeG276ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)