UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r4g7boiX9ayFNYX9I7jKZMSmrX0d63d+aP3g967dK7o='
WHERE
key_id = 'fd4cb20d1dcfa14b893286a48cf13d290f6afa13acb7fd5ddcd45ee9a188fe14'
AND (
token = 'r4g7boiX9ayFNYX9I7jKZMSmrX0d63d+aP3g967dK7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)