UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oG2daVroTbb8ix3rT5J0RPD2Z+1PQi8LO5CXnPRtWeg='
WHERE
key_id = '6d15d47225002162ee14c470fa0d67db746aa358b89654fd4090ac815e33c075'
AND (
token = 'oG2daVroTbb8ix3rT5J0RPD2Z+1PQi8LO5CXnPRtWeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)