UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gC5bUa7DPT6VTx5hUz6tdNpKzMzZYLTydte08f3/w9M='
WHERE
key_id = 'bdc18afc2a55839603fe86d7f32ca49135bfe9214928728871d23917249c2fd7'
AND (
token = 'gC5bUa7DPT6VTx5hUz6tdNpKzMzZYLTydte08f3/w9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)