UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6CgHQ4QGRqVA2+wMgO+O+0EmAyKnw66OBSRxG5gzl8='
WHERE
key_id = 'efe4b1a28952b9f1194f1fde0dad4d7dca278fa4d1b3a25093f5b1501a9a5f6e'
AND (
token = 'i6CgHQ4QGRqVA2+wMgO+O+0EmAyKnw66OBSRxG5gzl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)